package com.team2.insulatingtools.modular.tools.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.team2.insulatingtools.modular.tools.entity.Category;
import com.team2.insulatingtools.modular.tools.pojo.response.RecordStatisticsResponse;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 *.           ,%%%%%%%%,
 *.         ,%%/\%%%%/\%%
 *.        ,%%%\c "" J/%%%
 * %.       %%%%/ o  o \%%%
 * `%%.     %%%%    _  |%%%
 *  `%%      `%%%%(__Y__)%%'
 *  //        ;%%%%`\-/%%%'
 * ((        /  `%%%%%%%'
 *  \\    .'          |
 *   \\  /       \  | |
 *    \\/         ) | |
 *     \         /_ | |__
 *     (___________)))))))
攻城狮 永无bug!
 * @ClassName RecordStatisticsMapper
 * @Author lemon
 * @create 2023/4/6 16:33
 */
public interface RecordStatisticsMapper extends BaseMapper<RecordStatisticsResponse> {
    /**
     * @Author lemon
     * @Description //通过 orgName查找QuotaId
     * @Date 19:12 2023/4/6
     * @Param * @param orgName
     * @return * @return List<Integer>
     **/
    List<Integer> getToolsIdByName(@Param("orgName")String orgName);

    /**
     * @Author lemon
     * @Description //通过organizationId查找QuotaId
     * @Date 19:12 2023/4/6
     * @Param * @param organizationId
     * @return * @return List<Integer>
     **/
    List<Integer> getToolsIdById(@Param("organizationId") Long organizationId);

    /**
     * @Author lemon
     * @Description //通过QuotaId查找对应的工具及其详情
     * @Date 19:24 2023/4/6
     * @Param * @param quotaIdList
     * @return * @return List<RecordStatisticsResponse>
     **/
    RecordStatisticsResponse getRecordStatisticsList(@Param("toolsId")Integer toolsId,@Param("toolName")String toolName);

    List<String> getToolsOrgNameById(@Param("organizationId") Long organizationId);

    Integer getQuotaIdByTeamName(@Param("teamName") String teamName,@Param("toolName") String toolName);
    Integer getToolIdByTeamName(@Param("teamName") String teamName,@Param("toolName") String toolName,@Param("number") String number);




}
